Tabela Message

Definicja tabeli Message

Name

Message

Code

Message

Comment

 


Lista kolumn tabeli Message

Name

Code

MessageID

MessageID

MessageTypeID

MessageTypeID

MessageProblemID

MessageProblemID

ContractorID

ContractorID

AccountingErrorsID

AccountingErrorsID

Date

Date

No

No

Version

Version

ContractNo

ContractNo

FileName

FileName

Name

Name

Receiver

Receiver

Sender

Sender

ReceiverNo

ReceiverNo

nfzVersion

nfzVersion

TotalNumberOfItems

TotalNumberOfItems

ConfirmedNumberOfItems

ConfirmedNumberOfItems

Month

Month

Year

Year

ConfirmationDate

ConfirmationDate

Status

Status

CorrectionNo

CorrectionNo

AccountingConfirmationDate

AccountingConfirmationDate

ComputerName

ComputerName

ComputerIP

ComputerIP

ComputerUserName

ComputerUserName

UserName

UserName

SubMessageTypeID

SubMessageTypeID

NotValidatedNumberOfItems

NotValidatedNumberOfItems


Kolumna MessageID tabeli Message

Definicja kolumny MessageID tabeli Message

Name

MessageID

Code

MessageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MessageTypeID tabeli Message

Definicja kolumny MessageTypeID tabeli Message

Name

MessageTypeID

Code

MessageTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MessageProblemID tabeli Message

Definicja kolumny MessageProblemID tabeli Message

Name

MessageProblemID

Code

MessageProblemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli Message

Definicja kolumny ContractorID tabeli Message

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountingErrorsID tabeli Message

Definicja kolumny AccountingErrorsID tabeli Message

Name

AccountingErrorsID

Code

AccountingErrorsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Date tabeli Message

Definicja kolumny Date tabeli Message

Name

Date

Code

Date

Data Type

DATE

Mandatory

No

Comment

 


Kolumna No tabeli Message

Definicja kolumny No tabeli Message

Name

No

Code

No

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Version tabeli Message

Definicja kolumny Version tabeli Message

Name

Version

Code

Version

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna ContractNo tabeli Message

Definicja kolumny ContractNo tabeli Message

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FileName tabeli Message

Definicja kolumny FileName tabeli Message

Name

FileName

Code

FileName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Name tabeli Message

Definicja kolumny Name tabeli Message

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Receiver tabeli Message

Definicja kolumny Receiver tabeli Message

Name

Receiver

Code

Receiver

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna Sender tabeli Message

Definicja kolumny Sender tabeli Message

Name

Sender

Code

Sender

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna ReceiverNo tabeli Message

Definicja kolumny ReceiverNo tabeli Message

Name

ReceiverNo

Code

ReceiverNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna nfzVersion tabeli Message

Definicja kolumny nfzVersion tabeli Message

Name

nfzVersion

Code

nfzVersion

Data Type

VARCHAR2(5)

Mandatory

No

Comment

 


Kolumna TotalNumberOfItems tabeli Message

Definicja kolumny TotalNumberOfItems tabeli Message

Name

TotalNumberOfItems

Code

TotalNumberOfItems

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ConfirmedNumberOfItems tabeli Message

Definicja kolumny ConfirmedNumberOfItems tabeli Message

Name

ConfirmedNumberOfItems

Code

ConfirmedNumberOfItems

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Month tabeli Message

Definicja kolumny Month tabeli Message

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Year tabeli Message

Definicja kolumny Year tabeli Message

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ConfirmationDate tabeli Message

Definicja kolumny ConfirmationDate tabeli Message

Name

ConfirmationDate

Code

ConfirmationDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Status tabeli Message

Definicja kolumny Status tabeli Message

Name

Status

Code

Status

Data Type

VARCHAR2(3)

Mandatory

No

Comment

 


Kolumna CorrectionNo tabeli Message

Definicja kolumny CorrectionNo tabeli Message

Name

CorrectionNo

Code

CorrectionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountingConfirmationDate tabeli Message

Definicja kolumny AccountingConfirmationDate tabeli Message

Name

AccountingConfirmationDate

Code

AccountingConfirmationDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ComputerName tabeli Message

Definicja kolumny ComputerName tabeli Message

Name

ComputerName

Code

ComputerName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna ComputerIP tabeli Message

Definicja kolumny ComputerIP tabeli Message

Name

ComputerIP

Code

ComputerIP

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna ComputerUserName tabeli Message

Definicja kolumny ComputerUserName tabeli Message

Name

ComputerUserName

Code

ComputerUserName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna UserName tabeli Message

Definicja kolumny UserName tabeli Message

Name

UserName

Code

UserName

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna SubMessageTypeID tabeli Message

Definicja kolumny SubMessageTypeID tabeli Message

Name

SubMessageTypeID

Code

SubMessageTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NotValidatedNumberOfItems tabeli Message

Definicja kolumny NotValidatedNumberOfItems tabeli Message

Name

NotValidatedNumberOfItems

Code

NotValidatedNumberOfItems

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczba niezwalidowanych uslug w NFZ czyli ze statusem SWX_NFZ


Lista kluczy tabeli Message

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Message

Definicja klucza Identifier_1 tabeli Message

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment